-
Re: looking to return the next Monday + 1 week from a date
The logic goes this way assuming your date is 7/24/2022: If the day of the week is Sunday (aka 1) then return Date - (day of the week - 5) which is 7/24/22 - (1-5) = 7/24/22+4 =7/28 and if day is not…1 · -
Re: How to add an and/or statement into a sheet formula
=IF(AND([End Date]@row < TODAY(), OR([Status]@row = "Complete", [Status]@row = "Cancelled" )), 0, 1)1 · -
Re: how do I return a blank cell if source is empty
Try this: =IF(OR(ISBLANK([projected cost]@row), ISBLANK([Fedex Charged]@row)), "", ([projected cost]@row - [Fedex Charged]@row) / MAX([projected cost]@row:[Fedex Charged]@row) )1 · -
Re: Can I automatically adjust predecessor dates by changing the dependent date?
You should change the dates of the predecessor and not the task that it dependent on it. In your case change the date of "walk to pool" from 9/5/22 to 9/8/22 and rest will be automatically …2 · -
Re: How to Count number of boxes checked in a date range, Cross sheet formula
Try this; =COUNTTIFS({Checkbox Column Range}, 1, {Date Column Range}, AND(@cell >= DATE(2022,9,1), @cell <= DATE(2022,12,6)))1 ·